SQL Guide - NumericFunctions.Length expression (NumericFunctions)

Scalar functions to return the length of an item

Format

{ CHAR_LENGTH | CHARACTER_LENGTH | BIT_LENGTH | OCTET_LENGTH } ( expression )

{{ FN { CHAR_LENGTH | CHARACTER_LENGTH | BIT_LENGTH | OCTET_LENGTH } ( expression ) }}

The functions CHAR_LENGTH and CHARACTER_LENGTH both return the length, in characters, of a string expression.

The function BIT_LENGTH returns the length of a string or bit string in terms of a bit count.

The function OCTET_LENGTH returns the length of a string or bit string in terms of a byte count.

The length functions are also supported in the ODBC function syntax.

Example:

CHAR_LENGTH( CurrentStateDesc )

{FN OCTET_LENGTH( CurrentStateDesc )}